package bdsimple.dao.base;

import java.sql.SQLException;
import java.util.List;

import bdsimple.dto.base.VampiroDTO;
import dao.base.api.IDAO;

public interface VampiroDAO extends IDAO {
	
	public VampiroDTO loadByAlias(String alias) throws SQLException,Exception;
	
	public List<VampiroDTO> listAllOrderedByPtosExperiencia() throws SQLException,Exception;

    public List<VampiroDTO> listAllOrderedByPtosExperiencia(int lim, int off) throws SQLException,Exception;
    
    public List<VampiroDTO> listByAliasLike(String alias) throws SQLException, Exception ;
    
    public byte[] loadImageByVampiroId(int vampiroId) throws SQLException, Exception;
    
    public List<VampiroDTO> listAllOrderedByCiudad() throws SQLException, Exception;

    public List<VampiroDTO> listAllOrderedByCiudad(int lim, int off) throws SQLException, Exception;
    
    public VampiroDTO loadByCorreo(String correo) throws SQLException, Exception ;
    
}
